Append Range

AutomatR.DefaultActivities.WorkBook.AppendRange

The "Append Range" activity in AutomatR is part of the WorkBook activities package, allowing you to add information stored in a DataTable variable to the end of a specified Excel spreadsheet. This activity facilitates the dynamic updating of Excel files, enhancing data management in automation workflows.

Properties

Name	Description
Input
Data Table	Specifies the DataTable variable reference containing the information to be appended to the Excel spreadsheet. DataTable variables from other activities (e.g., Read Range).
Excel File Path	Specifies the full path of the Excel workbook on the local drive, including the filename (e.g., "C:\excelActivities\workbook.xlsx"). String variables containing the Excel file path.
Password	Specifies the password for the workbook if required. Object variables containing the password.
Sheet Name	Specifies the name of the spreadsheet in which you want to perform the action. String variables containing the sheet name.
Misc
Display Name	Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name.
Optional
Delay	Specifies the amount of time (in seconds) to wait before executing the "Append Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 5 seconds, enter 5.

How to use:

1. Drag and drop the "Append Range" activity onto the workflow.
2. Specify the full path of the Excel workbook, including the filename.
3. Specify the name of the sheet in which you want to append data.
4. Optionally, provide the password for the workbook if required.
5. Specify the DataTable variable reference containing the information to be appended.
6. Optionally, set the delay for the execution.
7. Execute the workflow to append the specified data to the Excel spreadsheet.

Example:

Consider an example where the "Append Range" activity is used to add information from a DataTable variable to the end of an Excel spreadsheet:

Append Range:
  Display Name: "Append Data to Excel"
  Excel File Path: "C:\excelActivities\workbook.xlsx"
  Sheet Name: "Sheet1"
  Password: workbookPassword
  Data Table: dataTableVariable

In this example, the activity appends data from the "dataTableVariable" to the "Sheet1" of the Excel workbook located at "C:\excelActivities\workbook.xlsx". If a password is required for the workbook, it is provided through the "workbookPassword" variable.

Note: Ensure that the Excel file path and sheet name are specified before executing this activity.